请问EXCEL一行相邻单元格等于另一行每隔3列(多列)的值该怎么表示?表1...答:D37 =OFFSET($J$3,0,(COLUMN(A1)-1)*3,1,1) 横拉复制公式 D9 =SUM(D5:G5,OFFSET(Sheet2!$D$11,0,(COLUMN(A1)-1)/4,1,1),OFFSET(Sheet2!$D$15,0,(COLUMN(A1)-1)/4,1,1)) 横拉复制公式
怎么在EXCEL中把一行变成多列?答:假设原数据在A和B列,如图:F2公式:=TRIM(MID(SUBSTITUTE(SUBSTITUTE(PHONETIC(B$2:B$100),",",""),"c",REPT(" ",LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",","")))&"c"),LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",",""))*ROW(A1)+1,LEN(SUBSTITUTE(PHONETIC(B$2:B$100),","...